Multiple open ResultSets not allowed?
От | Jeff Kolesky |
---|---|
Тема | Multiple open ResultSets not allowed? |
Дата | |
Msg-id | a05200f0dba981a8c0774@[192.168.1.6] обсуждение исходный текст |
Ответ на | idle in transaction ("Alexey Yudichev" <Alexey@francoudi.com>) |
Ответы |
Re: Multiple open ResultSets not allowed?
|
Список | pgsql-jdbc |
I have just switched to using the 7.3 JDBC driver and am no longer allowed to have multiple ResultSets open at the same time. When running code that iterates through two open ResultSets (from two different Statements from the same Connection), the following exception is thrown: Connection is closed. Operation is not permitted. at org.postgresql.jdbc1.AbstractJdbc1ResultSet.next (AbstractJdbc1ResultSet.java:92) I haven't looked at the AbstractJdbc1ResultSet code to see what is going on, but according to the JDBC Javadocs, "if the reading of one ResultSet object is interleaved with the reading of another, each must have been generated by different Statement objects." Therefore, the code I am executing should not throw this exception, and with the previous version of the driver it did not. Is this a known bug? Has it been fixed? Did I misinterpret the Javadocs? Thanks. Jeff
В списке pgsql-jdbc по дате отправления: